Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 8 Forum

Notes/Domino 8 Forum
Previous Next
Subject: SQL connection on other server
Feedback Type: Problem
Product Area: Notes 8 Client
Technical Area: Application development
Platform: ALL
Release: All
Reproducible: -Reproducibility-

Hi..
I have to connect lotus notes to SQL/MySQL server through Lotus notes. My code is as follows
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim result As New ODBCResultSet
Set qry.Connection = con
Set result.Query = qry
Call con.ConnectTo("IP Address of sql server","username","passwd")
If (con.IsConnected) Then
Print "Connected to DB... DSN=" & con.DataSourceName
End If

This code does not connect to the SQL server.

ODBC driver has to be installed on LN server? or is there anything else we are missing on??

Our server is running on Linux red hat 5.0

Please help...


Feedback number WEBB9QHF9U created by ~Tate Quetkisonlen on 11/03/2014

Status: Open
Comments:

SQL connection on other server (~Tate Quetkison... 3.Nov.14)
. . Java Agent (~Lex Umfreeterj... 18.Feb.15)
. . You would need an ODBC driver on yo... (~Anita Minaster... 18.Feb.15)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS